Bookkeeping Made Simple

What you'll learn

• Complete a bank reconciliation on excel

• Run a VAT Return using excel

• Do their bookkeeping using a simple spreadsheet

• Understand common accounting terminology

• Introduction 20:03

  • 1: BMS 1 - Aims of the course Preview 04:18
  • 2: BMS 2 - Organisng receipts Preview 08:42
  • 3: BMS 3 - Computerised systems 07:03

• The Theory and Manual Bookkeeping 13:55

  • 4: BMS 4 - The theory of bookkeeping 13:55

• Worked Example 23:52

  • 5: BMS 5 - Introuction to the company Flower Power 01:43
  • 6: BMS 6 - Download the template - explain the tabs on the ss 02:25
  • 7: BMS 7 - Enter income month1 07:27
  • 8: BMS 8 - Enter expenses month1 12:17

• Bank Reconciliation 08:45

  • 9: BMS 9 - Reconciling items month1 05:08
  • 10: BMS 10 - Recap bank recONCILIATION 03:37

• VAT Returns 12:18

  • 11: BMS 11 - VAT returns 07:54
  • 12: BMS 12 - VAT return month1 04:24

• Higher Level Bookkeeping 21:24

  • 13: BMS 13 - Adjustments 12:36
  • 14: BMS 14 - Reporting 03:38
  • 15: BMS 15 - Reporting PNL month1 05:10

• Home Work Month 2 35:24

  • 16: BMS 16 - Enter income month2 07:54
  • 17: BMS 17 - Enter expenses month2 07:30
  • 18: BMS 18 - Entering credit card items 06:30
  • 19: BMS 19 - Reconciling items month2 06:02
  • 20: BMS 20 - VAT return month2 04:02
  • 21: BMS 21 -Reporting month2 03:26

• Conclusion 01:40

  • 22: BMS 22 - Next Steps and conclusion Preview 01:40

The course is about how to do a bank reconciliation on excel and how to complete a UK VAT return on excel.

We'll cover terminology such as bank rec, nominal codes, VAT (codes and rates). Plus we'll look at how to take these figures to prepare a simple profit and loss account.

The course will take approx 1 hour to complete.

The course is structured in such a way to show you how to do bookkeeping using an excel template. This template is included to download so that you can have a go at using this yourself.

The template is a cashbook, and the bookkeeping is done on a cash basis. The template is in the form of a Microsoft Excel spreadsheet, version 2003, thus you will need Excel 2003 or a newer edition (2007, 2010...) in order to open the spreadsheet.

Once the bookkeeping is done, these figures can then be used to complete the VAT return. The VAT return is based on the UK laws and rules. The course shows you how to use the figures to do the VAT return.

The template has codes embedded which are the nominal codes. The course covers what nominal codes are and how they work with the template.

There is a worked example of a bank reconciliation.

It's an ideal course if you are working in the accounts / finance department and/or if you are thinking of embarking on a career in accountancy or bookkeeping and part of your requirement is to run the VAT return or do the bank rec and report back to the owners of the firm.

If you are thinking of starting your own business and want to understand how to do a bank rec and VAT on excel, then this course is for you.

If you have already began a business, and want a simple, effective method to do your bookkeeping - then this course is for you.

You need to know how to navigate around excel - a basic level of competence is needed. The template is sufficient for you to use in your own business. If you're comfortable with excel and prefer to do your books on this system, and not a specific accounting software, then you'll find this course useful.

• Bookkeepers, self-employed and small business owners looking for a simple effective bookkeeping method using an excel spreadsheet
• Its not for you if your business is growing and you need a 'proper' accounting software - take a look at one of our courses for actual bookkeeping software e.g. Sage, Quickbooks, Xero, Kashflow etc.,

• You will need to have excel 2003 (spreadsheets) or later e.g. 2007, 2010 version - as you'll be given a template to download and you need to be able to open it

• Bookkeeper
• Accounts Assistant

Currently there are no Q&As for this course. Be the first to ask a question.

Reed courses certificate of completion

Digital certificate - Included